<?xml version="1.0" encoding="utf-8"?>
<Query Version="V02" QueryName="PropertyQuery">
  <Columns>
    <ColumnName>KDOR_vwPropertyGeneral.CountyCode</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.AdHocTaxYear</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.QuickRefID</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.PropertyNumber</ColumnName>
    <ColumnName>cama_OthImpts.fmsclass</ColumnName>
    <ColumnName>cama_OthImpts.foccup</ColumnName>
    <ColumnName>cama_OthImpts.fyrblt</ColumnName>
    <ColumnName>KDOR_vwPropertyTransfer.SaleDate</ColumnName>
    <ColumnName>KDOR_vwPropertyTransfer.Price</ColumnName>
    <ColumnName>KDOR_vwPropertyTransfer.TransferValidityCode</ColumnName>
    <ColumnName>KDOR_vwPropertyTransfer.COV</ColumnName>
  </Columns>
  <Tables>
    <TableName>cama_OthImpts</TableName>
    <TableName>KDOR_vwPropertyTransfer</TableName>
  </Tables>
  <ActiveOnly>true</ActiveOnly>
  <Distinct>false</Distinct>
  <GroupBy>false</GroupBy>
  <Criteria>
    <ColumnName>KDOR_vwPropertyGeneral.AdHocTaxYear</ColumnName>
    <Not>false</Not>
    <Test>Equals</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>2015</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Criteria>
    <ColumnName>KDOR_vwPropertyTransfer.SaleDate</ColumnName>
    <Not>false</Not>
    <Test>Greater Than</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>12/31/2012</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Criteria>
    <ColumnName>cama_OthImpts.fyrblt</ColumnName>
    <Not>false</Not>
    <Test>Greater Than</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>2008</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Criteria>
    <ColumnName>KDOR_vwPropertyGeneral.TreeNodeID</ColumnName>
    <Not>false</Not>
    <Test>Equals</Test>
    <ColumnValueCheck>true</ColumnValueCheck>
    <ColumnValue>cama_OthImpts.LPParentNodeID</ColumnValue>
    <AndOr>And</AndOr>
  </Criteria>
  <Output>CSV</Output>
</Query>